create external table jms_dm.dm_reback_transfer_plan_sign_sum_dt 
(
manage_code                      string COMMENT '管理大区code' ,
manage_name                      string COMMENT '管理大区名字' ,
agent_code                       string COMMENT '代理区code' ,
agent_name                       string COMMENT '代理区名字' ,
franchisee_code                  string COMMENT '加盟商code' ,
franchisee_name                  string COMMENT '加盟商名字' ,
delivery_network_code            string COMMENT '派件网点code' ,
delivery_network_name            string COMMENT '派件网点名字' ,
order_source_name               string COMMENT '平台名字' ,
order_source_code                string COMMENT '平台code' ,
back_sign_cnt                    int COMMENT '应签收量' ,
before_sign_cnt                  int COMMENT '22点前签收量' ,
after_sign_cnt                   int COMMENT '22点后延误签收' ,
zypt_cnt                         int COMMENT '22点到24点签收量' ,
no_sign_cnt                      int COMMENT '未签收量' ,
ypy_cnt                          int COMMENT '一班应签收量' ,
ypz_cnt                          int COMMENT '一班准点签收的量' ,
epy_cnt                          int COMMENT '二班应签收的量' ,
epz_cnt                          int COMMENT '二班准点签收的量' ,
spy_cnt                          int COMMENT '三班应签收的量' ,
spz_cnt                          int COMMENT '三班准点签收的量' ,
date_time                        string COMMENT '业务日期' ,
need_sign_cnt_1030               int COMMENT '10：30应签收' ,
aging_sign_cnt_1030              int COMMENT '10：30准点签收' ,
need_sign_cnt_1130               int COMMENT '11：30应签收' ,
aging_sign_cnt_1130              int COMMENT '11：30准点签收' ,
need_sign_cnt_1400               int COMMENT '14：00应签收' ,
aging_sign_cnt_1400              int COMMENT '14：00准点签收' ,
need_sign_cnt_1800               int COMMENT '18：00应签收' ,
aging_sign_cnt_1800              int COMMENT '18：00准点签收' ,
need_sign_cnt_2200               int COMMENT '22:00应签收量' ,
aging_sign_cnt_2200              int COMMENT '22:00准点签收量' ,

departure_on_time_sum            int COMMENT '准点接件量' ,
departure_later_time_sum         int COMMENT '晚点接件量' ,
arrival_on_time_sum              int COMMENT '准点到车量' ,
arrival_later_time_sum           int COMMENT '晚点到车量' ,
deliver_on_time_sum              int COMMENT '准点派件量' ,
deliver_township_on_time_sum     int COMMENT '乡镇准点派件量' ,
deliver_later_time_sum           int COMMENT '不准点派件量' ,
deliver_township_later_time_sum  int COMMENT '乡镇不准点派件量',
send_need_sign_sum int comment '发件应签收总量'
)
comment '退件签收监控规划签收维度汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_reback_transfer_plan_sign_sum_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');


 alter table jms_dm.dm_reback_transfer_plan_sign_sum_dt add columns (
    no_appraisal_sum int comment'不考核汇总'
    ) cascade ;